﻿-- =========================================================================================================
-- Author:		MICHAEL RITACCO
-- Copyright:	2010 MEKHANO GROUP LLC
-- Version:		08/21/2010 1.0
-- =========================================================================================================
CREATE FUNCTION [flcrTM].[GetTMPeriodDate](@time_key int)
RETURNS date
AS
BEGIN
	DECLARE @ret date;
	 SELECT @ret = [PERIOD_DATE] FROM flcrTM.[PERIOD]
		           WHERE [TIME_KEY] = @time_key 
	RETURN @ret
END